Dataset statistics
| Number of variables | 30 |
|---|---|
| Number of observations | 227628 |
| Missing cells | 941504 |
| Missing cells (%) | 13.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 47.5 MiB |
| Average record size in memory | 219.0 B |
Variable types
| CAT | 18 |
|---|---|
| NUM | 8 |
| BOOL | 4 |
country has constant value "227628" | Constant |
months_per_bill_period has constant value "227628" | Constant |
language has constant value "227628" | Constant |
account_creation_date has a high cardinality: 226023 distinct values | High cardinality |
trial_end_date has a high cardinality: 226023 distinct values | High cardinality |
last_payment has a high cardinality: 131339 distinct values | High cardinality |
next_payment has a high cardinality: 129206 distinct values | High cardinality |
cancel_date has a high cardinality: 284 distinct values | High cardinality |
discount_price is highly correlated with monthly_price and 1 other fields | High correlation |
monthly_price is highly correlated with discount_price and 1 other fields | High correlation |
num_trial_days is highly correlated with monthly_price and 1 other fields | High correlation |
num_trial_days is highly correlated with plan_type | High correlation |
plan_type is highly correlated with num_trial_days | High correlation |
package_type has 35574 (15.6%) missing values | Missing |
num_weekly_services_utilized has 110450 (48.5%) missing values | Missing |
preferred_genre has 36326 (16.0%) missing values | Missing |
intended_use has 3549 (1.6%) missing values | Missing |
weekly_consumption_hour has 37930 (16.7%) missing values | Missing |
num_ideal_streaming_services has 112170 (49.3%) missing values | Missing |
age has 35169 (15.5%) missing values | Missing |
attribution_survey has 2644 (1.2%) missing values | Missing |
op_sys has 13375 (5.9%) missing values | Missing |
join_fee has 34904 (15.3%) missing values | Missing |
payment_type has 135578 (59.6%) missing values | Missing |
last_payment has 95391 (41.9%) missing values | Missing |
next_payment has 97378 (42.8%) missing values | Missing |
cancel_date has 190797 (83.8%) missing values | Missing |
age is highly skewed (γ1 = 403.3291721) | Skewed |
monthly_price is highly skewed (γ1 = -35.47057095) | Skewed |
discount_price is highly skewed (γ1 = -34.15730579) | Skewed |
account_creation_date is uniformly distributed | Uniform |
trial_end_date is uniformly distributed | Uniform |
last_payment is uniformly distributed | Uniform |
next_payment is uniformly distributed | Uniform |
subid has unique values | Unique |
join_fee has 33482 (14.7%) zeros | Zeros |
Reproduction
| Analysis started | 2020-12-04 13:26:07.485832 |
|---|---|
| Analysis finished | 2020-12-04 13:26:39.172769 |
| Duration | 31.69 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 227628 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24986239.81 |
|---|---|
| Minimum | 20000009 |
| Maximum | 29999982 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 20000009 |
|---|---|
| 5-th percentile | 20496214.8 |
| Q1 | 22489975.5 |
| median | 24970107.5 |
| Q3 | 27490204.75 |
| 95-th percentile | 29492191.3 |
| Maximum | 29999982 |
| Range | 9999973 |
| Interquartile range (IQR) | 5000229.25 |
Descriptive statistics
| Standard deviation | 2885543.308 |
|---|---|
| Coefficient of variation (CV) | 0.1154852963 |
| Kurtosis | -1.199613914 |
| Mean | 24986239.81 |
| Median Absolute Deviation (MAD) | 2500579 |
| Skewness | 0.007929852742 |
| Sum | 5.687567796e+12 |
| Variance | 8.32636018e+12 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 24643583 | 1 | < 0.1% | |
| 29903967 | 1 | < 0.1% | |
| 22623344 | 1 | < 0.1% | |
| 28429423 | 1 | < 0.1% | |
| 21559392 | 1 | < 0.1% | |
| 22670443 | 1 | < 0.1% | |
| 20053097 | 1 | < 0.1% | |
| 26866792 | 1 | < 0.1% | |
| 27366500 | 1 | < 0.1% | |
| 25991042 | 1 | < 0.1% | |
| Other values (227618) | 227618 | > 99.9% |
| Value | Count | Frequency (%) | |
| 20000009 | 1 | < 0.1% | |
| 20000048 | 1 | < 0.1% | |
| 20000062 | 1 | < 0.1% | |
| 20000094 | 1 | < 0.1% | |
| 20000104 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 29999982 | 1 | < 0.1% | |
| 29999945 | 1 | < 0.1% | |
| 29999904 | 1 | < 0.1% | |
| 29999889 | 1 | < 0.1% | |
| 29999879 | 1 | < 0.1% |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 35574 |
| Missing (%) | 15.6% |
| Memory size | 1.7 MiB |
| base | |
|---|---|
| enhanced | |
| economy |
| Value | Count | Frequency (%) | |
| base | 111464 | 49.0% | |
| enhanced | 63241 | 27.8% | |
| economy | 17349 | 7.6% | |
| (Missing) | 35574 | 15.6% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 8 |
|---|---|
| Median length | 4 |
| Mean length | 5.183672483 |
| Min length | 3 |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 110450 |
| Missing (%) | 48.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.008824182 |
|---|---|
| Minimum | 0 |
| Maximum | 14 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2 |
| median | 3 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 14 |
| Range | 14 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.8205257244 |
|---|---|
| Coefficient of variation (CV) | 0.2727064377 |
| Kurtosis | 2.350893503 |
| Mean | 3.008824182 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.022780299 |
| Sum | 352568 |
| Variance | 0.6732624644 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) | |
| 3 | 63944 | 28.1% | |
| 2 | 29773 | 13.1% | |
| 4 | 17323 | 7.6% | |
| 5 | 5033 | 2.2% | |
| 6 | 904 | 0.4% | |
| 7 | 138 | 0.1% | |
| 1 | 24 | < 0.1% | |
| 8 | 22 | < 0.1% | |
| 9 | 11 | < 0.1% | |
| 10 | 3 | < 0.1% | |
| Other values (2) | 3 | < 0.1% | |
| (Missing) | 110450 | 48.5% |
| Value | Count | Frequency (%) | |
| 0 | 2 | < 0.1% | |
| 1 | 24 | < 0.1% | |
| 2 | 29773 | 13.1% | |
| 3 | 63944 | 28.1% | |
| 4 | 17323 | 7.6% |
| Value | Count | Frequency (%) | |
| 14 | 1 | < 0.1% | |
| 10 | 3 | < 0.1% | |
| 9 | 11 | < 0.1% | |
| 8 | 22 | < 0.1% | |
| 7 | 138 | 0.1% |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 36326 |
| Missing (%) | 16.0% |
| Memory size | 1.7 MiB |
| comedy | |
|---|---|
| drama | |
| regional | 8990 |
| international | 6404 |
| other | 3907 |
| Value | Count | Frequency (%) | |
| comedy | 125129 | 55.0% | |
| drama | 46872 | 20.6% | |
| regional | 8990 | 3.9% | |
| international | 6404 | 2.8% | |
| other | 3907 | 1.7% | |
| (Missing) | 36326 | 16.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 13 |
|---|---|
| Median length | 6 |
| Mean length | 5.574090182 |
| Min length | 3 |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3549 |
| Missing (%) | 1.6% |
| Memory size | 1.7 MiB |
| access to exclusive content | |
|---|---|
| replace OTT | |
| supplement OTT | |
| expand regional access | |
| expand international access | |
| Other values (2) |
| Value | Count | Frequency (%) | |
| access to exclusive content | 89039 | 39.1% | |
| replace OTT | 69185 | 30.4% | |
| supplement OTT | 26603 | 11.7% | |
| expand regional access | 14025 | 6.2% | |
| expand international access | 12978 | 5.7% | |
| other | 7112 | 3.1% | |
| education | 5137 | 2.3% | |
| (Missing) | 3549 | 1.6% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 27 |
|---|---|
| Median length | 22 |
| Mean length | 18.84182087 |
| Min length | 3 |
| Distinct | 81 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 37930 |
| Missing (%) | 16.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.99772411 |
|---|---|
| Minimum | -32.1467596 |
| Maximum | 76.59996225 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | -32.1467596 |
|---|---|
| 5-th percentile | 21.50162318 |
| Q1 | 24.40153577 |
| median | 27.30144835 |
| Q3 | 30.20136093 |
| 95-th percentile | 37.45114239 |
| Maximum | 76.59996225 |
| Range | 108.7467219 |
| Interquartile range (IQR) | 5.799825165 |
Descriptive statistics
| Standard deviation | 4.976340586 |
|---|---|
| Coefficient of variation (CV) | 0.1777408966 |
| Kurtosis | 3.166855179 |
| Mean | 27.99772411 |
| Median Absolute Deviation (MAD) | 2.899912583 |
| Skewness | 0.6415334006 |
| Sum | 5311112.268 |
| Variance | 24.76396563 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 25.85149206 | 25990 | 11.4% | |
| 28.75140464 | 22947 | 10.1% | |
| 27.30144835 | 22551 | 9.9% | |
| 24.40153577 | 19968 | 8.8% | |
| 30.20136093 | 18366 | 8.1% | |
| 22.95157947 | 16839 | 7.4% | |
| 31.65131722 | 13262 | 5.8% | |
| 33.10127351 | 9411 | 4.1% | |
| 21.50162318 | 8720 | 3.8% | |
| 34.5512298 | 7424 | 3.3% | |
| Other values (71) | 24220 | 10.6% | |
| (Missing) | 37930 | 16.7% |
| Value | Count | Frequency (%) | |
| -32.1467596 | 1 | < 0.1% | |
| -29.24684701 | 4 | < 0.1% | |
| -27.79689072 | 1 | < 0.1% | |
| -23.44702185 | 1 | < 0.1% | |
| -13.29732781 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 76.59996225 | 3 | < 0.1% | |
| 75.15000596 | 3 | < 0.1% | |
| 73.70004967 | 1 | < 0.1% | |
| 72.25009338 | 5 | < 0.1% | |
| 67.90022451 | 5 | < 0.1% |
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 112170 |
| Missing (%) | 49.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.061260372 |
|---|---|
| Minimum | -1 |
| Maximum | 7 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 7 |
| Range | 8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2459068491 |
|---|---|
| Coefficient of variation (CV) | 0.1192992659 |
| Kurtosis | 14.18046344 |
| Mean | 2.061260372 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.601631299 |
| Sum | 237989 |
| Variance | 0.06047017843 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) | |
| 2 | 108245 | 47.6% | |
| 3 | 7072 | 3.1% | |
| 1 | 89 | < 0.1% | |
| 4 | 42 | < 0.1% | |
| 5 | 4 | < 0.1% | |
| 0 | 4 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| -1 | 1 | < 0.1% | |
| (Missing) | 112170 | 49.3% |
| Value | Count | Frequency (%) | |
| -1 | 1 | < 0.1% | |
| 0 | 4 | < 0.1% | |
| 1 | 89 | < 0.1% | |
| 2 | 108245 | 47.6% | |
| 3 | 7072 | 3.1% |
| Value | Count | Frequency (%) | |
| 7 | 1 | < 0.1% | |
| 5 | 4 | < 0.1% | |
| 4 | 42 | < 0.1% | |
| 3 | 7072 | 3.1% | |
| 2 | 108245 | 47.6% |
| Distinct | 278 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 35169 |
| Missing (%) | 15.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 757.9754574 |
|---|---|
| Minimum | 0 |
| Maximum | 81720000 |
| Zeros | 64 |
| Zeros (%) | < 0.1% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 35 |
| median | 46 |
| Q3 | 57 |
| 95-th percentile | 70 |
| Maximum | 81720000 |
| Range | 81720000 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 192020.4428 |
|---|---|
| Coefficient of variation (CV) | 253.3333248 |
| Kurtosis | 170584.1771 |
| Mean | 757.9754574 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 403.3291721 |
| Sum | 145879198.6 |
| Variance | 3.687185044e+10 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 50 | 6355 | 2.8% | |
| 40 | 5509 | 2.4% | |
| 60 | 5221 | 2.3% | |
| 48 | 4651 | 2.0% | |
| 47 | 4517 | 2.0% | |
| 55 | 4509 | 2.0% | |
| 49 | 4483 | 2.0% | |
| 52 | 4440 | 2.0% | |
| 43 | 4357 | 1.9% | |
| 42 | 4346 | 1.9% | |
| Other values (268) | 144071 | 63.3% | |
| (Missing) | 35169 | 15.5% |
| Value | Count | Frequency (%) | |
| 0 | 64 | < 0.1% | |
| 10 | 3 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 18 | 1097 | 0.5% | |
| 19 | 632 | 0.3% |
| Value | Count | Frequency (%) | |
| 81720000 | 1 | < 0.1% | |
| 11022000 | 1 | < 0.1% | |
| 10301949 | 1 | < 0.1% | |
| 8121930 | 1 | < 0.1% | |
| 8061990 | 1 | < 0.1% |
male_TF
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 269 |
| Missing (%) | 0.1% |
| Memory size | 1.7 MiB |
| False | |
|---|---|
| True | |
| (Missing) | 269 |
| Value | Count | Frequency (%) | |
| False | 200902 | 88.3% | |
| True | 26457 | 11.6% | |
| (Missing) | 269 | 0.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| UAE |
|---|
| Value | Count | Frequency (%) | |
| UAE | 227628 | 100.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
attribution_technical
Categorical
| Distinct | 33 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| search | |
|---|---|
| organic | |
| brand sem intent google | |
| Other values (28) |
| Value | Count | Frequency (%) | |
| 80251 | 35.3% | ||
| 25690 | 11.3% | ||
| search | 25306 | 11.1% | |
| organic | 22013 | 9.7% | |
| brand sem intent google | 18524 | 8.1% | |
| google_organic | 10691 | 4.7% | |
| affiliate | 9894 | 4.3% | |
| email_blast | 7277 | 3.2% | |
| 6065 | 2.7% | ||
| referral | 5170 | 2.3% | |
| Other values (23) | 16747 | 7.4% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 23 |
|---|---|
| Median length | 8 |
| Mean length | 9.204082977 |
| Min length | 2 |
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2644 |
| Missing (%) | 1.2% |
| Memory size | 1.7 MiB |
| tv | |
|---|---|
| referral | |
| search | 8492 |
| 7856 | |
| Other values (11) |
| Value | Count | Frequency (%) | |
| 119126 | 52.3% | ||
| tv | 39904 | 17.5% | |
| referral | 20882 | 9.2% | |
| search | 8492 | 3.7% | |
| 7856 | 3.5% | ||
| other | 6496 | 2.9% | |
| public_radio | 6219 | 2.7% | |
| social_organic | 3869 | 1.7% | |
| youtube | 3108 | 1.4% | |
| podcast | 2995 | 1.3% | |
| Other values (6) | 6037 | 2.7% | |
| (Missing) | 2644 | 1.2% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 16 |
|---|---|
| Median length | 8 |
| Mean length | 6.965918077 |
| Min length | 2 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 13375 |
| Missing (%) | 5.9% |
| Memory size | 1.7 MiB |
| iOS | |
|---|---|
| Android |
| Value | Count | Frequency (%) | |
| iOS | 143921 | 63.2% | |
| Android | 70332 | 30.9% | |
| (Missing) | 13375 | 5.9% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 7 |
|---|---|
| Median length | 3 |
| Mean length | 4.235911224 |
| Min length | 3 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| 4 |
|---|
| Value | Count | Frequency (%) | |
| 4 | 227628 | 100.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| base_uae_14_day_trial | |
|---|---|
| high_uae_14_day_trial | 325 |
| low_uae_no_trial | 167 |
| base_eur_14_day_trial | 18 |
| high_sar_14_day_trial | 12 |
| Other values (6) | 10 |
| Value | Count | Frequency (%) | |
| base_uae_14_day_trial | 227096 | 99.8% | |
| high_uae_14_day_trial | 325 | 0.1% | |
| low_uae_no_trial | 167 | 0.1% | |
| base_eur_14_day_trial | 18 | < 0.1% | |
| high_sar_14_day_trial | 12 | < 0.1% | |
| low_gbp_14_day_trial | 4 | < 0.1% | |
| high_aud_14_day_trial | 2 | < 0.1% | |
| high_jpy_14_day_trial | 1 | < 0.1% | |
| low_sar_no_trial | 1 | < 0.1% | |
| low_eur_no_trial | 1 | < 0.1% |
Frequencies of value counts
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Histogram of lengths of the category
Length
| Max length | 33 |
|---|---|
| Median length | 21 |
| Mean length | 20.99632295 |
| Min length | 16 |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.732049419 |
|---|---|
| Minimum | 0.8074 |
| Maximum | 5.1013 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 0.8074 |
|---|---|
| 5-th percentile | 4.7343 |
| Q1 | 4.7343 |
| median | 4.7343 |
| Q3 | 4.7343 |
| 95-th percentile | 4.7343 |
| Maximum | 5.1013 |
| Range | 4.2939 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1010488003 |
|---|---|
| Coefficient of variation (CV) | 0.02135413039 |
| Kurtosis | 1287.47917 |
| Mean | 4.732049419 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -35.47057095 |
| Sum | 1077146.945 |
| Variance | 0.01021086004 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) | |
| 4.7343 | 227101 | 99.8% | |
| 5.1013 | 325 | 0.1% | |
| 1.0643 | 167 | 0.1% | |
| 4.4407 | 18 | < 0.1% | |
| 4.3673 | 12 | < 0.1% | |
| 4.0003 | 2 | < 0.1% | |
| 1.1744 | 1 | < 0.1% | |
| 0.8074 | 1 | < 0.1% | |
| 4.6976 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.8074 | 1 | < 0.1% | |
| 1.0643 | 167 | 0.1% | |
| 1.1744 | 1 | < 0.1% | |
| 4.0003 | 2 | < 0.1% | |
| 4.3673 | 12 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5.1013 | 325 | 0.1% | |
| 4.7343 | 227101 | 99.8% | |
| 4.6976 | 1 | < 0.1% | |
| 4.4407 | 18 | < 0.1% | |
| 4.3673 | 12 | < 0.1% |
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.512188481 |
|---|---|
| Minimum | 0.7707 |
| Maximum | 5.0279 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 0.7707 |
|---|---|
| 5-th percentile | 4.5141 |
| Q1 | 4.5141 |
| median | 4.5141 |
| Q3 | 4.5141 |
| 95-th percentile | 4.5141 |
| Maximum | 5.0279 |
| Range | 4.2572 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.09707790925 |
|---|---|
| Coefficient of variation (CV) | 0.02151459533 |
| Kurtosis | 1231.974423 |
| Mean | 4.512188481 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -34.15730579 |
| Sum | 1027100.44 |
| Variance | 0.009424120464 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 4.5141 | 227096 | 99.8% | |
| 5.0279 | 325 | 0.1% | |
| 1.0276 | 167 | 0.1% | |
| 4.2205 | 18 | < 0.1% | |
| 4.0737 | 12 | < 0.1% | |
| 4.3673 | 4 | < 0.1% | |
| 4.4407 | 2 | < 0.1% | |
| 3.7801 | 2 | < 0.1% | |
| 1.1744 | 1 | < 0.1% | |
| 0.7707 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.7707 | 1 | < 0.1% | |
| 1.0276 | 167 | 0.1% | |
| 1.1744 | 1 | < 0.1% | |
| 3.7801 | 2 | < 0.1% | |
| 4.0737 | 12 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5.0279 | 325 | 0.1% | |
| 4.5141 | 227096 | 99.8% | |
| 4.4407 | 2 | < 0.1% | |
| 4.3673 | 4 | < 0.1% | |
| 4.2205 | 18 | < 0.1% |
| Distinct | 226023 |
|---|---|
| Distinct (%) | 99.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| 2020-03-14 18:22:06 | 3 |
|---|---|
| 2019-07-01 01:21:10 | 3 |
| 2020-02-29 17:58:30 | 3 |
| 2019-06-30 14:47:57 | 3 |
| 2019-11-17 16:24:52 | 3 |
| Other values (226018) |
| Value | Count | Frequency (%) | |
| 2020-03-14 18:22:06 | 3 | < 0.1% | |
| 2019-07-01 01:21:10 | 3 | < 0.1% | |
| 2020-02-29 17:58:30 | 3 | < 0.1% | |
| 2019-06-30 14:47:57 | 3 | < 0.1% | |
| 2019-11-17 16:24:52 | 3 | < 0.1% | |
| 2019-07-02 14:58:45 | 3 | < 0.1% | |
| 2020-02-29 19:26:26 | 3 | < 0.1% | |
| 2019-11-30 02:48:10 | 3 | < 0.1% | |
| 2019-12-28 16:35:34 | 3 | < 0.1% | |
| 2020-03-15 20:09:50 | 2 | < 0.1% | |
| Other values (226013) | 227599 | > 99.9% |
Frequencies of value counts
Unique
| Unique | 224427 ? |
|---|---|
| Unique (%) | 98.6% |
Histogram of lengths of the category
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
| Distinct | 226023 |
|---|---|
| Distinct (%) | 99.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| 2020-01-11 16:35:34 | 3 |
|---|---|
| 2019-07-14 14:47:57 | 3 |
| 2019-12-14 02:48:10 | 3 |
| 2019-07-16 14:58:45 | 3 |
| 2019-12-01 16:24:52 | 3 |
| Other values (226018) |
| Value | Count | Frequency (%) | |
| 2020-01-11 16:35:34 | 3 | < 0.1% | |
| 2019-07-14 14:47:57 | 3 | < 0.1% | |
| 2019-12-14 02:48:10 | 3 | < 0.1% | |
| 2019-07-16 14:58:45 | 3 | < 0.1% | |
| 2019-12-01 16:24:52 | 3 | < 0.1% | |
| 2020-03-14 19:26:26 | 3 | < 0.1% | |
| 2020-03-28 18:22:06 | 3 | < 0.1% | |
| 2019-07-15 01:21:10 | 3 | < 0.1% | |
| 2020-03-14 17:58:30 | 3 | < 0.1% | |
| 2019-12-10 00:24:38 | 2 | < 0.1% | |
| Other values (226013) | 227599 | > 99.9% |
Frequencies of value counts
Unique
| Unique | 224427 ? |
|---|---|
| Unique (%) | 98.6% |
Histogram of lengths of the category
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
initial_credit_card_declined
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 222.3 KiB |
| False | |
|---|---|
| True | 11203 |
| Value | Count | Frequency (%) | |
| False | 216425 | 95.1% | |
| True | 11203 | 4.9% |
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 34904 |
| Missing (%) | 15.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1151453836 |
|---|---|
| Minimum | -0.6606 |
| Maximum | 0.734 |
| Zeros | 33482 |
| Zeros (%) | 14.7% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | -0.6606 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.0367 |
| median | 0.0367 |
| Q3 | 0.1101 |
| 95-th percentile | 0.6606 |
| Maximum | 0.734 |
| Range | 1.3946 |
| Interquartile range (IQR) | 0.0734 |
Descriptive statistics
| Standard deviation | 0.1769706831 |
|---|---|
| Coefficient of variation (CV) | 1.536932507 |
| Kurtosis | 3.131999623 |
| Mean | 0.1151453836 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.026261329 |
| Sum | 22191.2789 |
| Variance | 0.03131862266 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=20)
| Value | Count | Frequency (%) | |
| 0.0367 | 109482 | 48.1% | |
| 0 | 33482 | 14.7% | |
| 0.3303 | 25314 | 11.1% | |
| 0.6606 | 12282 | 5.4% | |
| 0.1101 | 10648 | 4.7% | |
| 0.367 | 1333 | 0.6% | |
| 0.1835 | 146 | 0.1% | |
| -0.0367 | 9 | < 0.1% | |
| 0.6973 | 8 | < 0.1% | |
| 0.6239 | 6 | < 0.1% | |
| Other values (10) | 14 | < 0.1% | |
| (Missing) | 34904 | 15.3% |
| Value | Count | Frequency (%) | |
| -0.6606 | 2 | < 0.1% | |
| -0.3303 | 1 | < 0.1% | |
| -0.1101 | 1 | < 0.1% | |
| -0.0367 | 9 | < 0.1% | |
| 0 | 33482 | 14.7% |
| Value | Count | Frequency (%) | |
| 0.734 | 1 | < 0.1% | |
| 0.6973 | 8 | < 0.1% | |
| 0.6606 | 12282 | 5.4% | |
| 0.6239 | 6 | < 0.1% | |
| 0.5872 | 1 | < 0.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| ar |
|---|
| Value | Count | Frequency (%) | |
| ar | 227628 | 100.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 135578 |
| Missing (%) | 59.6% |
| Memory size | 1.7 MiB |
| Standard Charter | |
|---|---|
| Paypal | |
| RAKBANK | |
| CBD | |
| Najim | 2414 |
| Value | Count | Frequency (%) | |
| Standard Charter | 38810 | 17.0% | |
| Paypal | 30911 | 13.6% | |
| RAKBANK | 14831 | 6.5% | |
| CBD | 5080 | 2.2% | |
| Najim | 2414 | 1.1% | |
| Apple Pay | 4 | < 0.1% | |
| (Missing) | 135578 | 59.6% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 16 |
|---|---|
| Median length | 3 |
| Mean length | 5.90578927 |
| Min length | 3 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| 14 | |
|---|---|
| 0 | 170 |
| Value | Count | Frequency (%) | |
| 14 | 227458 | 99.9% | |
| 0 | 170 | 0.1% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 1.999253167 |
| Min length | 1 |
current_sub_TF
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 222.3 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) | |
| True | 130250 | 57.2% | |
| False | 97378 | 42.8% |
payment_period
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| 0 | |
|---|---|
| 1 | |
| 2 | |
| 3 | 2348 |
| Value | Count | Frequency (%) | |
| 0 | 95391 | 41.9% | |
| 1 | 86968 | 38.2% | |
| 2 | 42921 | 18.9% | |
| 3 | 2348 | 1.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct | 131339 |
|---|---|
| Distinct (%) | 99.3% |
| Missing | 95391 |
| Missing (%) | 41.9% |
| Memory size | 1.7 MiB |
| 2020-03-14 19:26:26 | 3 |
|---|---|
| 2020-03-08 19:00:43 | 3 |
| 2019-12-14 02:48:10 | 3 |
| 2020-02-29 12:16:18 | 3 |
| 2020-02-14 16:53:19 | 2 |
| Other values (131334) |
| Value | Count | Frequency (%) | |
| 2020-03-14 19:26:26 | 3 | < 0.1% | |
| 2020-03-08 19:00:43 | 3 | < 0.1% | |
| 2019-12-14 02:48:10 | 3 | < 0.1% | |
| 2020-02-29 12:16:18 | 3 | < 0.1% | |
| 2020-02-14 16:53:19 | 2 | < 0.1% | |
| 2020-01-22 14:57:28 | 2 | < 0.1% | |
| 2020-01-18 01:17:02 | 2 | < 0.1% | |
| 2020-03-25 05:48:58 | 2 | < 0.1% | |
| 2020-02-14 16:18:49 | 2 | < 0.1% | |
| 2020-01-16 11:50:04 | 2 | < 0.1% | |
| Other values (131329) | 132213 | 58.1% | |
| (Missing) | 95391 | 41.9% |
Frequencies of value counts
Unique
| Unique | 130445 ? |
|---|---|
| Unique (%) | 98.6% |
Histogram of lengths of the category
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 12.29495493 |
| Min length | 3 |
| Distinct | 129206 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 97378 |
| Missing (%) | 42.8% |
| Memory size | 1.7 MiB |
| 2020-07-08 19:00:43 | 3 |
|---|---|
| 2020-04-14 02:48:10 | 3 |
| 2020-03-28 18:22:06 | 3 |
| 2020-07-14 19:26:26 | 3 |
| 2020-06-29 12:16:18 | 3 |
| Other values (129201) |
| Value | Count | Frequency (%) | |
| 2020-07-08 19:00:43 | 3 | < 0.1% | |
| 2020-04-14 02:48:10 | 3 | < 0.1% | |
| 2020-03-28 18:22:06 | 3 | < 0.1% | |
| 2020-07-14 19:26:26 | 3 | < 0.1% | |
| 2020-06-29 12:16:18 | 3 | < 0.1% | |
| 2020-05-24 21:19:34 | 2 | < 0.1% | |
| 2020-05-12 16:04:44 | 2 | < 0.1% | |
| 2020-06-24 23:09:50 | 2 | < 0.1% | |
| 2020-04-02 15:12:04 | 2 | < 0.1% | |
| 2020-04-13 19:44:04 | 2 | < 0.1% | |
| Other values (129196) | 130225 | 57.2% | |
| (Missing) | 97378 | 42.8% |
Frequencies of value counts
Unique
| Unique | 128167 ? |
|---|---|
| Unique (%) | 98.4% |
Histogram of lengths of the category
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 12.15528845 |
| Min length | 3 |
| Distinct | 284 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 190797 |
| Missing (%) | 83.8% |
| Memory size | 1.7 MiB |
| 2019-07-13 00:00:00 | 431 |
|---|---|
| 2019-07-12 00:00:00 | 396 |
| 2019-07-14 00:00:00 | 384 |
| 2019-07-15 00:00:00 | 348 |
| 2019-07-11 00:00:00 | 321 |
| Other values (279) |
| Value | Count | Frequency (%) | |
| 2019-07-13 00:00:00 | 431 | 0.2% | |
| 2019-07-12 00:00:00 | 396 | 0.2% | |
| 2019-07-14 00:00:00 | 384 | 0.2% | |
| 2019-07-15 00:00:00 | 348 | 0.2% | |
| 2019-07-11 00:00:00 | 321 | 0.1% | |
| 2019-07-16 00:00:00 | 317 | 0.1% | |
| 2019-07-17 00:00:00 | 300 | 0.1% | |
| 2019-07-10 00:00:00 | 288 | 0.1% | |
| 2019-07-09 00:00:00 | 258 | 0.1% | |
| 2019-07-18 00:00:00 | 254 | 0.1% | |
| Other values (274) | 33534 | 14.7% | |
| (Missing) | 190797 | 83.8% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 19 |
|---|---|
| Median length | 3 |
| Mean length | 5.588855501 |
| Min length | 3 |
trial_completed
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 222.3 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) | |
| True | 200236 | 88.0% | |
| False | 27392 | 12.0% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| subid | package_type | num_weekly_services_utilized | preferred_genre | intended_use | weekly_consumption_hour | num_ideal_streaming_services | age | male_TF | country | attribution_technical | attribution_survey | op_sys | months_per_bill_period | plan_type | monthly_price | discount_price | account_creation_date | trial_end_date | initial_credit_card_declined | join_fee | language | payment_type | num_trial_days | current_sub_TF | payment_period | last_payment | next_payment | cancel_date | trial_completed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 21724479 | economy | NaN | comedy | access to exclusive content | NaN | NaN | NaN | False | UAE | Android | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-01-24 21:44:16 | 2020-02-07 21:44:16 | False | NaN | ar | Standard Charter | 14 | True | 1 | 2020-02-07 21:44:16 | 2020-06-07 21:44:16 | NaN | True | ||
| 1 | 23383224 | base | NaN | comedy | access to exclusive content | 22.951579 | NaN | 70.0 | False | UAE | NaN | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-03-01 15:44:35 | 2020-03-15 15:44:35 | False | 0.3303 | ar | NaN | 14 | True | 1 | 2020-03-15 15:44:35 | 2020-07-15 15:44:35 | NaN | True | ||
| 2 | 26844789 | enhanced | 3.0 | regional | replace OTT | 36.001186 | 2.0 | 25.0 | True | UAE | organic | iOS | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-12-07 16:37:06 | 2019-12-21 16:37:06 | False | 0.1101 | ar | NaN | 14 | False | 0 | NaN | NaN | NaN | True | |
| 3 | 29417030 | base | NaN | drama | replace OTT | 20.051667 | NaN | 30.0 | False | UAE | search | tv | Android | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-01-27 16:09:32 | 2020-02-10 16:09:32 | False | 0.0367 | ar | NaN | 14 | False | 0 | NaN | NaN | NaN | True |
| 4 | 26723159 | base | 4.0 | comedy | replace OTT | 22.951579 | 3.0 | 28.0 | False | UAE | discovery | youtube | iOS | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-10-05 12:57:07 | 2019-10-19 12:57:07 | False | 0.0367 | ar | NaN | 14 | True | 2 | 2020-02-19 12:57:07 | 2020-06-19 12:57:07 | NaN | True |
| 5 | 24810928 | base | NaN | comedy | access to exclusive content | 20.051667 | NaN | 70.0 | False | UAE | bing | tv | NaN | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-03-03 20:15:43 | 2020-03-17 20:15:43 | False | 0.3303 | ar | RAKBANK | 14 | True | 1 | 2020-03-17 20:15:43 | 2020-07-17 20:15:43 | NaN | True |
| 6 | 29726122 | base | 2.0 | comedy | access to exclusive content | 20.051667 | 2.0 | 61.0 | False | UAE | bing | search | Android | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-02-19 18:30:15 | 2020-03-04 18:30:15 | False | 0.3303 | ar | Standard Charter | 14 | True | 1 | 2020-03-04 18:30:15 | 2020-07-04 18:30:15 | NaN | True |
| 7 | 20299962 | base | 3.0 | drama | access to exclusive content | 34.551230 | 2.0 | 23.0 | False | UAE | referral | iOS | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-03-05 14:52:22 | 2020-03-19 14:52:22 | False | 0.0000 | ar | RAKBANK | 14 | True | 1 | 2020-03-19 14:52:22 | 2020-07-19 14:52:22 | NaN | True | |
| 8 | 24930568 | base | NaN | comedy | access to exclusive content | 25.851492 | NaN | 73.0 | False | UAE | iOS | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-02-23 17:50:25 | 2020-03-08 17:50:25 | False | 0.6606 | ar | NaN | 14 | True | 1 | 2020-03-08 17:50:25 | 2020-07-08 17:50:25 | NaN | True | ||
| 9 | 23452753 | economy | 3.0 | drama | replace OTT | 28.751405 | 2.0 | 71.0 | False | UAE | search | Android | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-01-21 14:17:53 | 2020-02-04 14:17:53 | False | 0.3303 | ar | NaN | 14 | False | 0 | NaN | NaN | 2020-01-27 00:00:00 | False |
Last rows
| subid | package_type | num_weekly_services_utilized | preferred_genre | intended_use | weekly_consumption_hour | num_ideal_streaming_services | age | male_TF | country | attribution_technical | attribution_survey | op_sys | months_per_bill_period | plan_type | monthly_price | discount_price | account_creation_date | trial_end_date | initial_credit_card_declined | join_fee | language | payment_type | num_trial_days | current_sub_TF | payment_period | last_payment | next_payment | cancel_date | trial_completed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 227618 | 22218943 | economy | NaN | comedy | replace OTT | 37.451142 | NaN | 67.0 | True | UAE | brand sem intent bing | referral | iOS | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-11-16 02:53:50 | 2019-11-30 02:53:50 | False | 0.0367 | ar | NaN | 14 | False | 0 | NaN | NaN | 2019-11-27 00:00:00 | False |
| 227619 | 25492551 | base | 3.0 | comedy | access to exclusive content | 30.201361 | 2.0 | 32.0 | False | UAE | Android | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-09-30 22:07:37 | 2019-10-14 22:07:37 | False | 0.0000 | ar | NaN | 14 | True | 2 | 2020-02-14 22:07:37 | 2020-06-14 22:07:37 | NaN | True | ||
| 227620 | 21928274 | base | NaN | drama | replace OTT | NaN | NaN | NaN | False | UAE | Android | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-01-14 02:04:52 | 2020-01-28 02:04:52 | False | NaN | ar | RAKBANK | 14 | False | 0 | NaN | NaN | NaN | True | ||
| 227621 | 25549852 | enhanced | NaN | comedy | access to exclusive content | 28.751405 | NaN | 61.0 | False | UAE | affiliate | Android | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-03-06 02:57:03 | 2020-03-20 02:57:03 | False | 0.3303 | ar | NaN | 14 | True | 1 | 2020-03-20 02:57:03 | 2020-07-20 02:57:03 | NaN | True | |
| 227622 | 25835684 | base | 2.0 | drama | access to exclusive content | 24.401536 | 2.0 | 43.0 | False | UAE | iOS | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-01-01 22:43:56 | 2020-01-15 22:43:56 | False | 0.0000 | ar | NaN | 14 | True | 1 | 2020-01-15 22:43:56 | 2020-05-15 22:43:56 | NaN | True | ||
| 227623 | 21434712 | enhanced | 3.0 | comedy | supplement OTT | 28.751405 | 2.0 | 38.0 | False | UAE | facebook_organic | iOS | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-11-17 14:12:33 | 2019-12-01 14:12:33 | False | 0.3303 | ar | NaN | 14 | True | 1 | 2019-12-01 14:12:33 | 2020-04-01 14:12:33 | NaN | True | |
| 227624 | 25843074 | enhanced | 2.0 | comedy | replace OTT | 27.301448 | 2.0 | 49.0 | False | UAE | google_organic | referral | iOS | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-12-06 18:02:13 | 2019-12-20 18:02:13 | False | 0.3303 | ar | Paypal | 14 | True | 1 | 2019-12-20 18:02:13 | 2020-04-20 18:02:13 | NaN | True |
| 227625 | 24799085 | base | NaN | comedy | access to exclusive content | 31.651317 | NaN | 45.0 | False | UAE | iOS | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-12-21 19:40:44 | 2020-01-04 19:40:44 | True | 0.0367 | ar | NaN | 14 | True | 1 | 2020-01-04 19:40:44 | 2020-05-04 19:40:44 | NaN | True | ||
| 227626 | 21308040 | base | NaN | comedy | access to exclusive content | NaN | NaN | NaN | False | UAE | iOS | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-01-17 23:58:51 | 2020-01-31 23:58:51 | False | NaN | ar | Paypal | 14 | True | 1 | 2020-01-31 23:58:51 | 2020-05-31 23:58:51 | NaN | True | ||
| 227627 | 20166335 | base | NaN | comedy | replace OTT | 25.851492 | NaN | 55.0 | False | UAE | organic | tv | iOS | 4 | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-11-26 19:09:09 | 2019-12-10 19:09:09 | False | 0.0367 | ar | NaN | 14 | False | 0 | NaN | NaN | 2019-12-09 00:00:00 | False |